import sqlalchemy
from sqlalchemy.orm import Mapped,mapped_column
from settings.publicvar import Base

class SchoolInfo(Base):
    __tablename__ = 'schoolinfo'

    id:Mapped[int] = mapped_column(primary_key=True)
    name:Mapped[str] = mapped_column(sqlalchemy.String(20))
    schoolnum:Mapped[str] = mapped_column(sqlalchemy.String(20))
    schoolsegment:Mapped[str]
    nature:Mapped[str]
    introduction:Mapped[str]
    address:Mapped[str]
    mark:Mapped[str] = mapped_column(nullable=True)

    def __repr__(self):
        return f'name:{self.name}'

